---------oracle---------------
drop SEQUENCE orders_serial_no;
CREATE SEQUENCE orders_serial_no
   START WITH 1000
   INCREMENT BY 1
   NOMAXVALUE;
select orders_serial_no.nextval from dual;